package cn.gson.crm.model.dao;

import cn.gson.crm.model.pojos.Work;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface WorkDao extends CrudRepository<Work,Integer> {
    //饼状统计图查询1
    @Query(nativeQuery = true,value = "select count(*) from WORK_ where Work_type=?1")
    public Integer selectWork(String Type);
    //饼状统计图查询2
    @Query(nativeQuery = true,value= "select count (*) from WORK_ where  yg_id=?1")
    public Integer sellApprover(long Approver);

}
